<?php
namespace api\bdd\table;

class perso extends table{

	public static $Chargement = 'SELECT 
			`p`.`mat`,
			`p`.`pseudo`,
			`r`.`nom`,
			`p`.`sexe`,
			`p`.`datearrive`,
			`p`.`dateprochaintour`,
			`p`.`basculedes`,
			`p`.`fortune`,
			`p`.`message`,
			`p`.`xp`,
			`p`.`pi`,
			(`p`.`pv_augmente` + `r`.`pv_base`) as `pv_max`,
			`p`.`pv_actuels`,
			(`p`.`pa_augmente` + `r`.`pa_base`) as `pa_max`,
			`p`.`pa_actuels`,
			(`p`.`mouv_augmente` + `r`.`mouv_base`) as `mouv_max`,
			`p`.`mouv_actuels`,
			(`p`.`degats` + `r`.`degats_base`) as `degats`,
			(`p`.`recuperation` + `r`.`recuperation_base`) as `recuperation`,
			(`p`.`perception` + `r`.`perception_base`) as `perception`,
			`p`.`attaque`,
			(`p`.`des_augmente` + `r`.`des_base`) as `des`	
		FROM `perso` as `p` 
		INNER JOIN `race` as `r` ON (`p`.`race` = `r`.`id`)
		WHERE ?';


}